from typing import TYPE_CHECKING

from app.db.base_class import Base
from sqlalchemy import Boolean, Column, Integer, String, text, TIMESTAMP, BigInteger, Numeric


class PickerInstrument(Base):
    __tablename__ = 'tb_picker_instrument'

    id = Column(BigInteger, primary_key=True)
    pickerId = Column('picker_id', BigInteger)
    instrumentId = Column('instrument_Id', Integer, nullable=False)
    probability = Column(Numeric(2, 2))
    type = Column(Integer)
    createdDate = Column('created_date', TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'))


